
DROP TABLE IF EXISTS `t_pay_way`;
CREATE TABLE `t_pay_way` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `way_code` varchar(20) NOT NULL COMMENT '支付方式代码  例如： wxpay_jsapi',
  `way_name` varchar(20) NOT NULL COMMENT '支付方式名称',
  `state` tinyint(4) DEFAULT '1' COMMENT '状态：0-失效 1-有效',
  `created_by` varchar(64) DEFAULT NULL COMMENT '创建人',
  `updated_by` varchar(64) DEFAULT NULL COMMENT '更新人',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `pay_way_code` (`way_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='支付方式表';

-- ----------------------------
-- Records of t_pay_way
-- ----------------------------
BEGIN;
INSERT INTO `t_pay_way`(way_code, way_name) VALUES ('ALI_APP', '支付宝APP');
INSERT INTO `t_pay_way`(way_code, way_name) VALUES ('ALI_BAR', '支付宝条码');
INSERT INTO `t_pay_way`(way_code, way_name) VALUES ('ALI_JSAPI', '支付宝生活号');
INSERT INTO `t_pay_way`(way_code, way_name) VALUES ('ALI_LITE', '支付宝小程序');
INSERT INTO `t_pay_way`(way_code, way_name) VALUES ('ALI_PC', '支付宝PC网站');
INSERT INTO `t_pay_way`(way_code, way_name) VALUES ('ALI_QR', '支付宝二维码');
INSERT INTO `t_pay_way`(way_code, way_name) VALUES ('ALI_WAP', '支付宝WAP');
INSERT INTO `t_pay_way`(way_code, way_name) VALUES ('PP_PC', 'PayPal支付');
INSERT INTO `t_pay_way`(way_code, way_name) VALUES ('UP_APP', '银联App支付');
INSERT INTO `t_pay_way`(way_code, way_name) VALUES ('UP_B2B', '银联企业网银支付');
INSERT INTO `t_pay_way`(way_code, way_name) VALUES ('UP_BAR', '银联二维码(被扫)');
INSERT INTO `t_pay_way`(way_code, way_name) VALUES ('UP_JSAPI', '银联Js支付');
INSERT INTO `t_pay_way`(way_code, way_name) VALUES ('UP_PC', '银联网关支付');
INSERT INTO `t_pay_way`(way_code, way_name) VALUES ('UP_QR', '银联二维码(主扫)');
INSERT INTO `t_pay_way`(way_code, way_name) VALUES ('UP_WAP', '银联手机网站支付');
INSERT INTO `t_pay_way`(way_code, way_name) VALUES ('WX_APP', '微信APP');
INSERT INTO `t_pay_way`(way_code, way_name) VALUES ('WX_BAR', '微信条码');
INSERT INTO `t_pay_way`(way_code, way_name) VALUES ('WX_H5', '微信H5');
INSERT INTO `t_pay_way`(way_code, way_name) VALUES ('WX_JSAPI', '微信公众号');
INSERT INTO `t_pay_way`(way_code, way_name) VALUES ('WX_LITE', '微信小程序');
INSERT INTO `t_pay_way`(way_code, way_name) VALUES ('WX_NATIVE', '微信扫码');
INSERT INTO `t_pay_way`(way_code, way_name) VALUES ('YSF_BAR', '云闪付条码');
INSERT INTO `t_pay_way`(way_code, way_name) VALUES ('YSF_JSAPI', '云闪付jsapi');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
